Index Seek
Short Description
Index Seek retrieves rows from a nonclustered index.
Detailed Description
The Index Seek operator uses the structure of a nonclustered index to retrieve either single rows or a subset of rows. The SEEK operator positions the start of the retrieval, and an optional WHERE predicate allows rows to be filtered further. If the step is passed the ORDERED clause, the rows will be returned in index sorted order. If the ORDERED clause is missing, rows will be returned in the most efficient way which may not by in sorted order.
Additional Links
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.